When the spreadsheet is set to the size of the viewable range and you turn automatic sizing on, the spreadsheet expands and shrinks on the Web page depending on content. It changes size as necessary when you insert and delete rows and columns, or when you change row heights or column widths.
If you want to prevent the spreadsheet from expanding beyond a specified size, type a value